Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- DROP TABLE

  A guide on installing and running Clickhouse on macOS

ClickHouse is a high-performance open-source columnar database management system developed by Yandex. Here are some of the key features of ClickHouse: Columnar storage: ClickHouse uses a columnar storage format, which allows it to efficiently store and retrieve data by column, rather than by row. This results in much faster query performance, especially for analytical and aggregate queries. Real-time data processing: ClickHouse is designed to handle real-time data processing and can handle bill...

   CLICKHOUSE,MACOS     2023-02-15 06:04:55

  Code Refurbishment

Within our industry we use a huge range of terminology.  Unfortunately we don’t all agree on what individual terms actually mean.  I so often hear people misuse the term “Refactoring” which has come to make the business in many organisations recoil in fear.  The reason for this fear I’ve observed is because of what people often mean when misusing this term.I feel we are holding back our industry by not being disciplined in our use of terminology.  If...

   Code Refurbishment,Code design,terminolo     2011-09-05 08:17:14

  Spending Too Much on Your Streaming Services? Read This

Remember the times when we thought ditching the cable TV might be a good idea to save time as well as all that money? Little did we know that platforms like Netflix, Hotstar, Hulu, HBO, Paramount, Disney Plus, and Apple TV Plus together cost more than the cable alone.  On the brighter side, there are ways to curb your streaming costs without much sacrifice. Do you want to binge-watch all your favorite shows at much fewer costs? Read on some great tips to save all that streaming costs to wa...

   NETFLIX,STREAMING     2022-06-13 07:20:37

  Create trigger in MySQL

To create trigger in MySQL, the syntax is :CREATE [DEFINER = { user | CURRENT_USER }] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_bodyOne example is :DELIMITER %%DROP TRIGGER IF EXISTS delete_commentCREATE TRIGGER delete_comment AFTER DELETE ON file_generate_infoFOR EACH ROW BEGIN DELETE FROM article_comment WHERE article_id=OLD.article_id;END%%The whole create trigger statement should be complete statement but not many separate com...

   MySQL,Trigger,Dilimiter,phpMyAdmin     2011-04-20 15:35:30

  About C++ comma operator precedence

When learning programming language, we will always have one topic about the operator precedence. Since there are many operators can be used in one expression, there should be some rules regarding which operation can happen first so that the compiler or interpreter can handle them correctly. One rule of programming with expression is using as much as brackets as you can to avoid unexpected results. Here we refer one problem we see online about the comma operator in C++. The following program has ...

   comma,precedence     2012-11-12 10:25:00

  Round Peg, Square Hole: How to Know If a Developer is a Good Fit for Your Team

Over the last few months, we have been recruiting developers, and we’ve started to get a sense for the type of developer who is a good fit for our team.  These attributes probably apply for developers at most web startups, so I wanted to share them with you. Before I get into it, the most important thing to know is that technical skill is a threshold requirement.  The assumption is that any person who is a fit for our team will have the relevant technical experience t...

   Recruitment,Gire ,Employee,Skill     2011-07-09 09:50:54

  Rebirth of Microsoft?

Only from the point of view of design and products, Microsoft may seem like an ongoing decline of the old giant: IE browser market share continues to drop, PC market continues to shrink where Windows depends on and tablet PC market gets rapid expansion, Windows Mobile, Windows phone perform not so well, even CEO Steve Ballmer is often ridiculed and accused. All these seem to indicate that Microsoft's golden era is over. But on the other hand, while its net profit for the past two years has ...

   Microsoft,Rebirth,change     2012-10-05 20:09:15

  5 Pro Tips Social Media Managers Swear By

Digital marketing is ruling the world, and rightly so. It's cost-effective, it increases business growth and helps in building a brand reputation. But to get successful results, it is important to target the right audience. This is where a social media manager’s experience helps. Social media managers create and manage a brand’s promotion strategy by monitoring the activity of their core audience. They are responsible for handling social media accounts and running marketing campaigns...

   SOCIAL MEDIA     2021-05-02 06:51:18

  Don't Overload #nil?

There’s a popular post on Hacker News about writing confident code by, among other things, overloading Object#nil? and returning “null objects” instead of nil itself.DO NOT DO THIS.In Ruby, all objects (except nil itself) coerce to the boolean value true. Your object will be nil and true at the same time. Bad things will happen. Your coworkers will cry. Sad people from around the world will ask bewildering questions on your mailing list.Here’s what happen...

   Ruby,#nil,Overload,Object     2011-11-10 10:50:22

  The 15 Golden Rules of UI design and flow.

Last night a good friend of mine showed me the latest Need for Speed game on the iphone / ipad. Quite an impressive feat of rendering and a relatively good game to boot. However, the front end, wow, a classic case in UI mis-engineering. Loads of stats, pages and pages of bits and pieces to wade through – a classic case of over stimulating the player with lots of decisions they have no business making – stuff that will significantly change their game play experience but being...

   UI design,Game design,Feature     2012-04-05 12:20:18

RECENT